BEGIN;

ALTER TABLE win_observer DROP COLUMN address cascade;
ALTER TABLE win_observer ADD COLUMN address1 character varying;
ALTER TABLE win_observer ADD COLUMN address2 character varying;
ALTER TABLE win_observer ADD COLUMN city character varying;
ALTER TABLE win_observer ADD COLUMN region character varying;
ALTER TABLE win_observer ADD COLUMN country character varying;

COMMIT;